package mianyang.zhangsan.com.mapper;

import mianyang.zhangsan.com.pojo.ScoreStats;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository("scoreStatsMapper")
public interface ScoreStatsMapper{

    @Select("select max(score) as maxScore,avg(score) as avgScore, min(score) as minScore from s_score where course_id = 1")
    ScoreStats queryScoreStats(int courseId);
}
